🕷️️ Job Radar • SCRAPING

upwork.com 2026-04-26 🟡

🔹 Verify firm status and service offerings through Google searches
👤 Client: 🇺🇸 USA Member since 2026-04-15
💰 Price: $20
🚩 Problem: Ensure accuracy and relevance of provided firm data for investment banking services.
📦 Existing: Google Sheets file with 1800 firms, no existing verification mechanism.

Specifications:

[Target] Firms listed in the Google Sheets document
[Method] Automated web scraping using Python libraries like BeautifulSoup or Selenium, followed by manual review where necessary
[UI/UX] Not applicable; focus on backend data processing
[Stack] Python (with BeautifulSoup/Selenium), Pandas for data manipulation, Google Sheets API for integration
[Security] Ensure all web requests are rate-limited to avoid IP blocking. Use secure authentication methods when accessing the Google Sheets API.
[Format] JSON or CSV output with additional columns for verification status

Workflow:

1. Import the provided Google Sheets file into a Python environment using the gspread library.
2. For each firm, perform automated web scraping to search for relevant information on their current status and service offerings.
3. Manually review scraped data where necessary to ensure accuracy.
4. Add columns to the dataset indicating whether each firm is operational, acquired, or does not offer investment banking services.
5. Export the updated dataset back into a Google Sheets file with the new columns.